fairnesscoop / permacoop

export class UserAdministrative1588426823331 implements MigrationInterface {

    name = 'UserAdministrative1588426823331'

    public async up(queryRunner: QueryRunner): Promise<any> {

        await queryRunner.query(`CREATE TYPE "user_administrative_contract_enum" AS ENUM('cdi', 'cdd', 'ctt', 'apprenticeship', 'professionalization')`, undefined);

        await queryRunner.query(`CREATE TABLE "user_administrative" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "joiningDate" TIMESTAMP NOT NULL, "leavingDate" TIMESTAMP, "annualEarnings" integer NOT NULL, "transportFee" integer DEFAULT 0, "healthInsurance" boolean NOT NULL, "executivePosition" boolean NOT NULL, "contract" "user_administrative_contract_enum" NOT NULL, CONSTRAINT "PK_3a17ceae75a0f330edb671f4b76" PRIMARY KEY ("id"))`, undefined);

        await queryRunner.query(`ALTER TABLE "user" DROP COLUMN "entryDate"`, undefined);

    }

    public async down(queryRunner: QueryRunner): Promise<any> {

        await queryRunner.query(`ALTER TABLE "user" ADD "entryDate" TIMESTAMP`, undefined);

        await queryRunner.query(`DROP TABLE "user_administrative"`, undefined);

        await queryRunner.query(`DROP TYPE "user_administrative_contract_enum"`, undefined);